<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>How to create a formatting rule</title>
    <link rel="StyleSheet" href="css/format.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="fm-HowToDeleteAStyle.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="fm-HowToModifyAFormattingRule.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h4 class="N_hth_HowToHelp"><a name="239932">How to create a formatting rule</a></h4>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="239935">In the layout editor, select the report element to format conditionally.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="257326">Choose the Highlights tab in Property Editor. The Highlights page appears, as shown in </a><a href="#257320" title="How to create a formatting rule">Figure&nbsp;6-11</a>. It is empty if you have not yet specified any formatting rules for the selected element.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i2_Image2"><a name="257318"><img class="Default" src="images/highlights.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 6-11 Highlights page" /></a></p>
      <div class="fc2_FigCall2Title">
        <b class="Bold">Figure&nbsp;6-11&nbsp;&nbsp;</b><a name="257320">Highlights page</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="337384">Choose Add to add a new formatting rule. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="337387">In New Highlight, create the rule for applying a particular format to the report element by completing the following steps:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732283464567pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="337388">Think of the rule in plain English first. For example:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="cfi2_CodeFirstIndent2"><a name="262379">If the order total is greater than $50,000.00, then set</a></div>
      <div class="coi2_CodeIndent2"><a name="262380">the font color to blue and the font style to bold.</a></div>
      <div class="N_i2_Indent2"><a name="138795">There are two parts to the rule: If (condition) and Then (format). The New Highlight dialog helps you specify the condition and format parts of the rule by breaking them down to more specific parts.</a></div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732283464567pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="138798">Specify the condition part of the rule by completing the following steps:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n3_NumList3_outer" style="margin-left: 28.3464566929134pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n3_NumList3_inner" style="width: 14.173228346456703pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray2">1&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n3_NumList3_inner"><a name="138799">In the first field, specify the first part of the conditional expression. Using the example rule, this part is order total:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b4_Bullet4_outer" style="margin-left: 42.5196850393701pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b4_Bullet4_inner" style="width: 14.173228346456696pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b4_Bullet4_inner"><a name="337687">If the order total values come directly from the selected element, from the drop-down list, choose Value of this data item.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b4_Bullet4_outer" style="margin-left: 42.5196850393701pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b4_Bullet4_inner" style="width: 14.173228346456696pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b4_Bullet4_inner"><a name="337688">If the order total values come from another data element, choose that element’s column binding name from the drop-down list.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n3_NumList3_outer" style="margin-left: 28.3464566929134pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n3_NumList3_inner" style="width: 14.173228346456703pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray2">2&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n3_NumList3_inner"><a name="337689">In the second field, specify the second part of the conditional expression by selecting an option from the list. Using our example rule, this part is Greater than. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n3_NumList3_outer" style="margin-left: 28.3464566929134pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n3_NumList3_inner" style="width: 14.173228346456703pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray2">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n3_NumList3_inner"><a name="337394">In the third field, specify the third part of the conditional expression. Using our example rule, this part is a value of 50000, as shown in </a><a href="#257300" title="How to create a formatting rule">Figure&nbsp;6-12</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i4_Image4"><a name="257312"><img class="Default" src="images/ifcondition.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 6-12 Elements of the conditional expression" /></a></p>
      <div class="fc4_FigCall4Title">
        <b class="Bold">Figure&nbsp;6-12&nbsp;&nbsp;</b><a name="257300">Elements of the conditional expression</a></div>
      <div class="N_i2_Indent2"><a name="257302">You have now completed the condition part of the rule, which specifies the following:</a></div>
      <div class="cfi2_CodeFirstIndent2"><a name="138817">If row["OrderTotal"] is greater than 50000</a></div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732283464567pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">3&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="138818">Specify the format part of the rule, which is “then set the font color to blue and the font style to bold,” by completing the following steps:</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b3_Bullet3_outer" style="margin-left: 28.3464566929134pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b3_Bullet3_inner" style="width: 14.173228346456703pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b3_Bullet3_inner"><a name="138820">Choose Color, then select a color from the color picker.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="N_si_ScanIcon"><a name="257284"><img class="Default" src="images/bold_button.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Bold button" /></a></p>
      <div class="b3_Bullet3_outer" style="margin-left: 28.3464566929134pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b3_Bullet3_inner" style="width: 14.173228346456703pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b3_Bullet3_inner"><a name="257288">Choose B to select the Bold format, as shown in </a><a href="#237806" title="How to create a formatting rule">Figure&nbsp;6-13</a>.</div>
            </td>
          </tr>
        </table>
      </div>
      <p class="i4_Image4"><a name="257292"><img class="Default" src="images/thencondition.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 6-13 Elements of the formatting expression in New Highlight" /></a></p>
      <div class="fc4_FigCall4Title">
        <b class="Bold">Figure&nbsp;6-13&nbsp;&nbsp;</b><a name="237806">Elements of the formatting expression in New Highlight</a></div>
      <div class="b3_Bullet3_outer" style="margin-left: 28.3464566929134pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b3_Bullet3_inner" style="width: 14.173228346456703pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b3_Bullet3_inner"><a name="293649">Alternatively, if you created a style named order_data_highlight, for example, that specifies the formats, you can select the style from the list of styles next to Apply Style.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_n2_NumList2_outer" style="margin-left: 14.1732283464567pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n2_NumList2_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023FormatGray">4&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n2_NumList2_inner"><a name="138827">Choose OK to save the highlight rule.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="N_i2_Indent2"><a name="223896">The rule that you created appears in Highlight List, as shown in </a><a href="#237882" title="How to create a formatting rule">Figure&nbsp;6-14</a>. The rule takes effect the next time you run the report.</div>
      <p class="i3_Image3"><a name="138832"><img class="Default" src="images/highlightslist.png" style="display: inline; float: none; left: 0.0; top: 0.0" alt="Figure 6-14 Highlight List" /></a></p>
      <div class="fc3_FigCall3Title">
        <b class="Bold">Figure&nbsp;6-14&nbsp;&nbsp;</b><a name="237882">Highlight List</a></div>
      <div class="N_n1_NumList1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="N_n1_NumList1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <span class="zAuto_0023Format">5&nbsp;&nbsp;</span>
              </div>
            </td>
            <td width="100%">
              <div class="N_n1_NumList1_inner"><a name="138834">Preview the report to test your formatting rule.</a></div>
            </td>
          </tr>
        </table>
      </div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>